Skip to content
  • Try Smartsheet

    • Kelsey Seitter

    Kelsey Seitter

    Kelsey Seitter ✭✭✭

    Overview

    Overview
    Roles
    Member
    Badges12

    About Me

    About Me
    Area of ExpertiseFormulas, Workapps, Sheets, Reports, Dashboards
    How I Use SmartsheetProject Management
    Linkedinhttps://www.linkedin.com/in/kelsey-seitter-bb51a154/

    Analytics

    10
    22
    373

    Reactions

    • Re: Formula syntax error

      Hi Alicia, What error does your formula produce? This is helpful in diagnosing what the issue might be. Looking at your formula, adding a few changes to the syntax should work: =IF([Status]@row="…
      ·

    • Re: Formula syntax error

      @Alicia Delahunty - looks like the issue is around bracket placement - much easier to see from your sheet screenshot, so that is helpful. =IF([Status]@row="Skipped", 0, IF([Actual Duration …
      ·
    Default Avatar

    Badges

    • Community 10th Anniversary
    • Synergizer
    • Innovator
    • $1B in annualized recurring revenue
    • Question of the Month: November Participant
    • Early Adopters Program
    • Second Anniversary
    • Photogenic
    • First Anniversary
    • First Answer
    • Name Dropper
    • First Comment